home *** CD-ROM | disk | FTP | other *** search
/ Power Programmierung / Power-Programmierung (Tewi)(1994).iso / magazine / dbms_mag / 9103 / sql5.mar < prev    next >
Text File  |  1991-01-22  |  126b  |  2 lines
  1.  
  2. CREATE VIEW city_hist (city, yr, total_sales) AS  SELECT city, YEAR(date), SUM(price*qty) FROM whole_db   GROUP BY 1, 2;